<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>数据库字典</title>
</head>
<body>
<p>utf8mb4_admin_log管理员访问日志表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">uid</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">管理员id</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">menu_name</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">菜单名称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">url</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">访问的url控制器</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">get</td>
                        <td class="c2 td2">text</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">get参数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">post</td>
                        <td class="c2 td2">text</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">post参数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">req_type</td>
                        <td class="c2 td2">varchar(10)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">请求类型</td>
                    </tr></tbody></table><p>utf8mb4_admin_login_log管理员登录日志表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">uid</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">登录用户的uid</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">field</td>
                        <td class="c2 td2">varchar(20)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">登录的字段手机/用户名</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">ip</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">登录的ip</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">status</td>
                        <td class="c2 td2">tinyint(2)</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">登录状态1成功0失败</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">password</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">登陆的错误密码</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">登录时间</td>
                    </tr></tbody></table><p>utf8mb4_admin_menu菜单表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">pid</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">父菜单id</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">name</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">菜单名称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">is_menu</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">是否是菜单1是</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">desc</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">简介</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">url</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">url</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">url_type</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">url模式</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">icon</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2">&#xe6b4;</td>
                        <td class="c6 td2">图标</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">sort</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">排序号</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">update_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">最后修改时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">delete_time</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">0表示未删除</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">app_id</td>
                        <td class="c2 td2">int(10)</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">项目id</td>
                    </tr></tbody></table><p>utf8mb4_admin_role角色表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">role_id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">name</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">角色名称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">status</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">状态1可用0不可用</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">update_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">最后修改时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">introduce</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">简介</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">app_id</td>
                        <td class="c2 td2">int(10)</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">应用id 99999系统后台  </td>
                    </tr>
                    <tr>
                        <td class="c1 td2">type</td>
                        <td class="c2 td2">tinyint(2)</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">角色类型  1增加 2减少</td>
                    </tr></tbody></table><p>utf8mb4_admin_role_auth角色权限表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">role_id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1">角色id</td>
        </tr>
                    <tr>
                        <td class="c1 td2">menu_id</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">菜单id</td>
                    </tr></tbody></table><p>utf8mb4_admin_user管理员用户表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">uid</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">username</td>
                        <td class="c2 td2">varchar(10)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">登录用户名</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">name</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">姓名</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">password</td>
                        <td class="c2 td2">char(32)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">密码</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">phone</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">手机号</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">email</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">邮箱</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">salt</td>
                        <td class="c2 td2">char(5)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">加密的字符串</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">error_num</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">密码错误次数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">status</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">状态1可用0不可用</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">role_id</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">1超级管理员</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">update_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">最后修改时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">sso_status</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">单点登录0关闭1开启</td>
                    </tr></tbody></table><p>utf8mb4_admin_visit_log</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">date</td>
                        <td class="c2 td2">date</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">日期</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">uid</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">用户的uid</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">ip</td>
                        <td class="c2 td2">varchar(20)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">首次访问的ip</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">last_ip</td>
                        <td class="c2 td2">varchar(20)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">最后访问的ip</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">visit_time</td>
                        <td class="c2 td2">datetime</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">首次访问时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">last_visit_time</td>
                        <td class="c2 td2">datetime</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">最后访问时间</td>
                    </tr></tbody></table><p>utf8mb4_data_summary_admin后台每日数据统计表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">date</td>
                        <td class="c2 td2">date</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2"></td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_user</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录人数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_num</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录次数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_success_num</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录成功次数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_fail_num</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录失败次数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_success_user</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录成功人数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">login_fail_user</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员登录失败人数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">visit_user</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">管理员访问人数</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">update_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">最后修改时间</td>
                    </tr></tbody></table><p>utf8mb4_region_list区域信息表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">region_code</td>
            <td class="c2 td1">varchar(6)</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1">区域编码</td>
        </tr>
                    <tr>
                        <td class="c1 td2">region_name</td>
                        <td class="c2 td2">varchar(32)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">区域名称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">region_name_short</td>
                        <td class="c2 td2">varchar(32)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">区域简称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">pid</td>
                        <td class="c2 td2">varchar(6)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">上级区域编码</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">has_child</td>
                        <td class="c2 td2">tinyint(1)</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">是否包含下级区域</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">px</td>
                        <td class="c2 td2">smallint(5)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">自定义排序字段</td>
                    </tr></tbody></table><p>utf8mb4_sys_conf系统配置表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">name</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2">名称</td>
                        <td class="c6 td2"></td>
                    </tr>
                    <tr>
                        <td class="c1 td2">key</td>
                        <td class="c2 td2">varchar(20)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2"></td>
                    </tr>
                    <tr>
                        <td class="c1 td2">value</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2"></td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">update_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">最后修改时间</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">type</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">类型1字符串2json</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">desc</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">简介</td>
                    </tr></tbody></table><p>utf8mb4_upload_list文件上传日志表</p>
<table border="1">
    <tbody>
        <tr style="height:15.6000pt; ">
            <th><span>字段名</span></th>
            <th><span>数据类型</span></th>
            <th><span>默认值</span></th>
            <th><span>备注</span></th>
        </tr>
        <tr>
            <td class="c1 td1">id</td>
            <td class="c2 td1">int(10) unsigned</td>
            <td class="c3 td1">column_comment</td>
            <td class="c4 td1"></td>
        </tr>
                    <tr>
                        <td class="c1 td2">name</td>
                        <td class="c2 td2">varchar(50)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">保存的文件名称</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">uid</td>
                        <td class="c2 td2">int(10) unsigned</td>
                        <td class="c3 td2">0</td>
                        <td class="c6 td2">上传的用户默认为系统上传</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">from</td>
                        <td class="c2 td2">tinyint(2) unsigned</td>
                        <td class="c3 td2">1</td>
                        <td class="c6 td2">来源1控件2编辑器</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">url</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">文件url</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">ext</td>
                        <td class="c2 td2">varchar(10)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2">文件后缀</td>
                    </tr>
                    <tr>
                        <td class="c1 td2">introduce</td>
                        <td class="c2 td2">varchar(255)</td>
                        <td class="c3 td2"></td>
                        <td class="c6 td2"></td>
                    </tr>
                    <tr>
                        <td class="c1 td2">add_time</td>
                        <td class="c2 td2">timestamp</td>
                        <td class="c3 td2">CURRENT_TIMESTAMP</td>
                        <td class="c6 td2">添加时间</td>
                    </tr></tbody></table>
</body>
</html>